go
create database DestDB
on primary
(name='DestDB_date',
filename='F:\Dest\DestDB_date.mdf',
size=5mb,
maxsize=100mb,
filegrowth=10%
),
filegroup fg
(
name='DestDB2_date',
filename='F:\Dest\DestDB2_date.mdf',
size=4mb,
filegrowth=10%
)
log on
(
name='DestDB_log',
filename='F:\Dest\DestDB_log.ldf',
size=3mb,
filegrowth=0
),
(name='DestDB2_log',
filename='F:\Dest\DestDB2_log.ldf',
size=3mb,
filegrowth=10%,
maxsize=100mb
)


go

use DestDB
go

drop table DestDB
